Profiling Report

Dataset statistics

Number of variables	24
Number of observations	12694445
Missing cells	96336624
Missing cells (%)	31.6%
Duplicate rows	32022
Duplicate rows (%)	0.3%
Total size in memory	9.3 GiB
Average record size in memory	786.0 B

Variable types

Categorical	10
Numeric	13
Unsupported	1

Alerts

Dataset has 32022 (0.3%) duplicate rows	Duplicates
`ImportDate` has a high cardinality: 266 distinct values	High cardinality
`FederalTIN` has a high cardinality: 335 distinct values	High cardinality
`PlanId` has a high cardinality: 16808 distinct values	High cardinality
`RatingAreaId` has a high cardinality: 67 distinct values	High cardinality
`IssuerId` is highly overall correlated with `IssuerId2`	High correlation
`IssuerId2` is highly overall correlated with `IssuerId`	High correlation
`IndividualRate` is highly overall correlated with `IndividualTobaccoRate` and 7 other fields	High correlation
`IndividualTobaccoRate` is highly overall correlated with `IndividualRate`	High correlation
`Couple` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`PrimarySubscriberAndOneDependent` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`PrimarySubscriberAndTwoDependents` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`PrimarySubscriberAndThreeOrMoreDependents` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`CoupleAndOneDependent` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`CoupleAndTwoDependents` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`CoupleAndThreeOrMoreDependents` is highly overall correlated with `IndividualRate` and 7 other fields	High correlation
`BusinessYear` is highly overall correlated with `RateEffectiveDate` and 1 other fields	High correlation
`StateCode` is highly overall correlated with `SourceName`	High correlation
`SourceName` is highly overall correlated with `StateCode`	High correlation
`RateEffectiveDate` is highly overall correlated with `BusinessYear` and 1 other fields	High correlation
`RateExpirationDate` is highly overall correlated with `BusinessYear` and 1 other fields	High correlation
`Tobacco` is highly overall correlated with `Couple` and 6 other fields	High correlation
`IndividualTobaccoRate` has 7762096 (61.1%) missing values	Missing
`Couple` has 12653504 (99.7%) missing values	Missing
`PrimarySubscriberAndOneDependent` has 12653504 (99.7%) missing values	Missing
`PrimarySubscriberAndTwoDependents` has 12653504 (99.7%) missing values	Missing
`PrimarySubscriberAndThreeOrMoreDependents` has 12653504 (99.7%) missing values	Missing
`CoupleAndOneDependent` has 12653504 (99.7%) missing values	Missing
`CoupleAndTwoDependents` has 12653504 (99.7%) missing values	Missing
`CoupleAndThreeOrMoreDependents` has 12653504 (99.7%) missing values	Missing
`Age` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`IndividualRate` has 682484 (5.4%) zeros	Zeros

Reproduction

Analysis started	2023-03-01 22:46:46.025028
Analysis finished	2023-03-01 22:55:34.586002
Duration	8 minutes and 48.56 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

BusinessYear
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	738.5 MiB

2015	4676092
2016	4221965
2014	3796388

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	50777780
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014
2nd row	2014
3rd row	2014
4th row	2014
5th row	2014

Common Values

Value	Count	Frequency (%)
2015	4676092	36.8%
2016	4221965	33.3%
2014	3796388	29.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2015	4676092	36.8%
2016	4221965	33.3%
2014	3796388	29.9%

Most occurring characters

Value	Count	Frequency (%)
2	12694445	25.0%
0	12694445	25.0%
1	12694445	25.0%
5	4676092	9.2%
6	4221965	8.3%
4	3796388	7.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	50777780	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	12694445	25.0%
0	12694445	25.0%
1	12694445	25.0%
5	4676092	9.2%
6	4221965	8.3%
4	3796388	7.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	50777780	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	12694445	25.0%
0	12694445	25.0%
1	12694445	25.0%
5	4676092	9.2%
6	4221965	8.3%
4	3796388	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50777780	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	12694445	25.0%
0	12694445	25.0%
1	12694445	25.0%
5	4676092	9.2%
6	4221965	8.3%
4	3796388	7.5%

StateCode
Categorical

Distinct	39
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	714.3 MiB

FL	1702472
SC	1563770
MI	1023190
WI	1013278
OH	884530
Other values (34)	6507205

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	25388890
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AK
2nd row	AK
3rd row	AK
4th row	AK
5th row	AK

Common Values

Value	Count	Frequency (%)
FL	1702472	13.4%
SC	1563770	12.3%
MI	1023190	8.1%
WI	1013278	8.0%
OH	884530	7.0%
TX	859714	6.8%
IN	677393	5.3%
PA	475022	3.7%
GA	472012	3.7%
IL	432827	3.4%
Other values (29)	3590237	28.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fl	1702472	13.4%
sc	1563770	12.3%
mi	1023190	8.1%
wi	1013278	8.0%
oh	884530	7.0%
tx	859714	6.8%
in	677393	5.3%
pa	475022	3.7%
ga	472012	3.7%
il	432827	3.4%
Other values (29)	3590237	28.3%

Most occurring characters

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249738	4.9%
Other values (14)	6080039	23.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	25388890	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249738	4.9%
Other values (14)	6080039	23.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25388890	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249738	4.9%
Other values (14)	6080039	23.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25388890	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249738	4.9%
Other values (14)	6080039	23.9%

IssuerId
Real number (ℝ)

Distinct	910
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52485.924

Minimum	10046
Maximum	99969
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	10046
5-th percentile	15560
Q1	30219
median	49532
Q3	76526
95-th percentile	97325
Maximum	99969
Range	89923
Interquartile range (IQR)	46307

Descriptive statistics

Standard deviation	26412.627
Coefficient of variation (CV)	0.50323257
Kurtosis	-1.1584024
Mean	52485.924
Median Absolute Deviation (MAD)	20676
Skewness	0.26753761
Sum	6.6627968 × 10¹¹
Variance	6.9762685 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49532	694048	5.5%
15560	340968	2.7%
33602	287040	2.3%
16842	277426	2.2%
84670	275172	2.2%
50816	258060	2.0%
38166	210450	1.7%
97325	166152	1.3%
65122	162932	1.3%
26065	156584	1.2%
Other values (900)	9865613	77.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10046	184	< 0.1%
10064	68	< 0.1%
10091	12144	0.1%
10191	31096	0.2%
10204	672	< 0.1%
10207	3680	< 0.1%
10739	736	< 0.1%
11083	26624	0.2%
11103	3212	< 0.1%
11245	552	< 0.1%

Value	Count	Frequency (%)
99969	59708	0.5%
99787	58558	0.5%
99734	16167	0.1%
99708	5184	< 0.1%
99663	6256	< 0.1%
99568	56	< 0.1%
99389	5796	< 0.1%
99248	4830	< 0.1%
99180	9142	0.1%
99129	552	< 0.1%

SourceName
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	742.0 MiB

HIOS	8702452
SERFF	3853855
OPM	138138

Length

Max length	5
Median length	4
Mean length	4.2927042
Min length	3

Characters and Unicode

Total characters	54493497
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HIOS
2nd row	HIOS
3rd row	HIOS
4th row	HIOS
5th row	HIOS

Common Values

Value	Count	Frequency (%)
HIOS	8702452	68.6%
SERFF	3853855	30.4%
OPM	138138	1.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hios	8702452	68.6%
serff	3853855	30.4%
opm	138138	1.1%

Most occurring characters

Value	Count	Frequency (%)
S	12556307	23.0%
O	8840590	16.2%
H	8702452	16.0%
I	8702452	16.0%
F	7707710	14.1%
E	3853855	7.1%
R	3853855	7.1%
P	138138	0.3%
M	138138	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	54493497	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	12556307	23.0%
O	8840590	16.2%
H	8702452	16.0%
I	8702452	16.0%
F	7707710	14.1%
E	3853855	7.1%
R	3853855	7.1%
P	138138	0.3%
M	138138	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	54493497	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	12556307	23.0%
O	8840590	16.2%
H	8702452	16.0%
I	8702452	16.0%
F	7707710	14.1%
E	3853855	7.1%
R	3853855	7.1%
P	138138	0.3%
M	138138	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	54493497	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	12556307	23.0%
O	8840590	16.2%
H	8702452	16.0%
I	8702452	16.0%
F	7707710	14.1%
E	3853855	7.1%
R	3853855	7.1%
P	138138	0.3%
M	138138	0.3%

VersionNum
Real number (ℝ)

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.8655583

Minimum	1
Maximum	24
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	6
Q3	9
95-th percentile	14
Maximum	24
Range	23
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.85718
Coefficient of variation (CV)	0.56181592
Kurtosis	3.2115208
Mean	6.8655583
Median Absolute Deviation (MAD)	2
Skewness	1.4067974
Sum	87154452
Variance	14.877837
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
6	1525820	12.0%
4	1506044	11.9%
7	1454216	11.5%
9	1447516	11.4%
8	1327285	10.5%
5	1179399	9.3%
3	1082273	8.5%
2	747516	5.9%
10	667468	5.3%
1	389078	3.1%
Other values (13)	1367830	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	389078	3.1%
2	747516	5.9%
3	1082273	8.5%
4	1506044	11.9%
5	1179399	9.3%
6	1525820	12.0%
7	1454216	11.5%
8	1327285	10.5%
9	1447516	11.4%
10	667468	5.3%

Value	Count	Frequency (%)
24	24840	0.2%
23	48254	0.4%
21	13110	0.1%
20	265466	2.1%
19	17986	0.1%
18	10580	0.1%
17	2438	< 0.1%
16	39514	0.3%
15	98900	0.8%
14	202308	1.6%

ImportDate
Categorical

Distinct	266
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	920.1 MiB

2013-11-26 13:14:08	511886
2015-08-22 15:09:32	451312
2015-08-26 09:56:12	449302
2015-01-16 17:32:32	433342
2014-01-17 09:36:20	351302
Other values (261)	10497301

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	241194455
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014-03-19 07:06:49
2nd row	2014-03-19 07:06:49
3rd row	2014-03-19 07:06:49
4th row	2014-03-19 07:06:49
5th row	2014-03-19 07:06:49

Common Values

Value	Count	Frequency (%)
2013-11-26 13:14:08	511886	4.0%
2015-08-22 15:09:32	451312	3.6%
2015-08-26 09:56:12	449302	3.5%
2015-01-16 17:32:32	433342	3.4%
2014-01-17 09:36:20	351302	2.8%
2014-01-21 08:29:49	312902	2.5%
2014-03-19 07:06:49	284962	2.2%
2015-10-18 12:35:12	266088	2.1%
2015-04-22 11:06:15	250608	2.0%
2013-11-27 09:24:34	230908	1.8%
Other values (256)	9151833	72.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-08-22	563080	2.2%
2013-11-26	511886	2.0%
13:14:08	511886	2.0%
15:09:32	451312	1.8%
2015-01-16	449478	1.8%
2015-08-26	449302	1.8%
09:56:12	449302	1.8%
17:32:32	433342	1.7%
2014-01-21	372982	1.5%
2014-01-17	363584	1.4%
Other values (457)	20832736	82.1%

Most occurring characters

Value	Count	Frequency (%)
1	40737378	16.9%
0	38711097	16.0%
2	32770658	13.6%
-	25388890	10.5%
:	25388890	10.5%
5	14513171	6.0%
4	14122006	5.9%
	12694445	5.3%
3	11405835	4.7%
8	8240114	3.4%
Other values (3)	17221971	7.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	177722230	73.7%
Dash Punctuation	25388890	10.5%
Other Punctuation	25388890	10.5%
Space Separator	12694445	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	40737378	22.9%
0	38711097	21.8%
2	32770658	18.4%
5	14513171	8.2%
4	14122006	7.9%
3	11405835	6.4%
8	8240114	4.6%
9	7307904	4.1%
6	5500384	3.1%
7	4413683	2.5%

Dash Punctuation

Value	Count	Frequency (%)
-	25388890	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	25388890	100.0%

Space Separator

Value	Count	Frequency (%)
	12694445	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	241194455	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	40737378	16.9%
0	38711097	16.0%
2	32770658	13.6%
-	25388890	10.5%
:	25388890	10.5%
5	14513171	6.0%
4	14122006	5.9%
	12694445	5.3%
3	11405835	4.7%
8	8240114	3.4%
Other values (3)	17221971	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	241194455	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	40737378	16.9%
0	38711097	16.0%
2	32770658	13.6%
-	25388890	10.5%
:	25388890	10.5%
5	14513171	6.0%
4	14122006	5.9%
	12694445	5.3%
3	11405835	4.7%
8	8240114	3.4%
Other values (3)	17221971	7.1%

IssuerId2
Real number (ℝ)

Distinct	910
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52485.924

Minimum	10046
Maximum	99969
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	10046
5-th percentile	15560
Q1	30219
median	49532
Q3	76526
95-th percentile	97325
Maximum	99969
Range	89923
Interquartile range (IQR)	46307

Descriptive statistics

Standard deviation	26412.627
Coefficient of variation (CV)	0.50323257
Kurtosis	-1.1584024
Mean	52485.924
Median Absolute Deviation (MAD)	20676
Skewness	0.26753761
Sum	6.6627968 × 10¹¹
Variance	6.9762685 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49532	694048	5.5%
15560	340968	2.7%
33602	287040	2.3%
16842	277426	2.2%
84670	275172	2.2%
50816	258060	2.0%
38166	210450	1.7%
97325	166152	1.3%
65122	162932	1.3%
26065	156584	1.2%
Other values (900)	9865613	77.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10046	184	< 0.1%
10064	68	< 0.1%
10091	12144	0.1%
10191	31096	0.2%
10204	672	< 0.1%
10207	3680	< 0.1%
10739	736	< 0.1%
11083	26624	0.2%
11103	3212	< 0.1%
11245	552	< 0.1%

Value	Count	Frequency (%)
99969	59708	0.5%
99787	58558	0.5%
99734	16167	0.1%
99708	5184	< 0.1%
99663	6256	< 0.1%
99568	56	< 0.1%
99389	5796	< 0.1%
99248	4830	< 0.1%
99180	9142	0.1%
99129	552	< 0.1%

FederalTIN
Categorical

Distinct	335
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	811.1 MiB

57-0768835	694048
47-0397286	613192
36-1236610	519432
13-5581829	425624
95-6042390	353843
Other values (330)	10088306

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	126944450
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	93-0438772
2nd row	93-0438772
3rd row	93-0438772
4th row	93-0438772
5th row	93-0438772

Common Values

Value	Count	Frequency (%)
57-0768835	694048	5.5%
47-0397286	613192	4.8%
36-1236610	519432	4.1%
13-5581829	425624	3.4%
95-6042390	353843	2.8%
38-2069753	340968	2.7%
75-1233841	283820	2.2%
59-2015694	277426	2.2%
20-2660193	275172	2.2%
31-1069321	258060	2.0%
Other values (325)	8652860	68.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
57-0768835	694048	5.5%
47-0397286	613192	4.8%
36-1236610	519432	4.1%
13-5581829	425624	3.4%
95-6042390	353843	2.8%
38-2069753	340968	2.7%
75-1233841	283820	2.2%
59-2015694	277426	2.2%
20-2660193	275172	2.2%
31-1069321	258060	2.0%
Other values (325)	8652860	68.2%

Most occurring characters

Value	Count	Frequency (%)
3	15865123	12.5%
0	12932923	10.2%
-	12694445	10.0%
1	12304992	9.7%
5	12120009	9.5%
2	11659245	9.2%
6	10796362	8.5%
9	10335050	8.1%
8	9958719	7.8%
7	9473461	7.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	114250005	90.0%
Dash Punctuation	12694445	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	15865123	13.9%
0	12932923	11.3%
1	12304992	10.8%
5	12120009	10.6%
2	11659245	10.2%
6	10796362	9.4%
9	10335050	9.0%
8	9958719	8.7%
7	9473461	8.3%
4	8804121	7.7%

Dash Punctuation

Value	Count	Frequency (%)
-	12694445	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126944450	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	15865123	12.5%
0	12932923	10.2%
-	12694445	10.0%
1	12304992	9.7%
5	12120009	9.5%
2	11659245	9.2%
6	10796362	8.5%
9	10335050	8.1%
8	9958719	7.8%
7	9473461	7.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126944450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	15865123	12.5%
0	12932923	10.2%
-	12694445	10.0%
1	12304992	9.7%
5	12120009	9.5%
2	11659245	9.2%
6	10796362	8.5%
9	10335050	8.1%
8	9958719	7.8%
7	9473461	7.5%

RateEffectiveDate
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	811.1 MiB

2015-01-01	2951582
2016-01-01	2669814
2014-01-01	2382530
2015-07-01	583820
2015-10-01	570848
Other values (9)	3535851

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	126944450
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014-01-01
2nd row	2014-01-01
3rd row	2014-01-01
4th row	2014-01-01
5th row	2014-01-01

Common Values

Value	Count	Frequency (%)
2015-01-01	2951582	23.3%
2016-01-01	2669814	21.0%
2014-01-01	2382530	18.8%
2015-07-01	583820	4.6%
2015-10-01	570848	4.5%
2015-04-01	570848	4.5%
2016-07-01	525495	4.1%
2016-04-01	512799	4.0%
2016-10-01	512799	4.0%
2014-07-01	476132	3.8%
Other values (4)	937778	7.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-01-01	2951582	23.3%
2016-01-01	2669814	21.0%
2014-01-01	2382530	18.8%
2015-07-01	583820	4.6%
2015-10-01	570848	4.5%
2015-04-01	570848	4.5%
2016-07-01	525495	4.1%
2016-04-01	512799	4.0%
2016-10-01	512799	4.0%
2014-07-01	476132	3.8%
Other values (4)	937778	7.4%

Most occurring characters

Value	Count	Frequency (%)
0	38084103	30.0%
1	34950787	27.5%
-	25388890	20.0%
2	12694445	10.0%
4	5342727	4.2%
5	4677098	3.7%
6	4220907	3.3%
7	1585447	1.2%
3	46	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	101555560	80.0%
Dash Punctuation	25388890	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	38084103	37.5%
1	34950787	34.4%
2	12694445	12.5%
4	5342727	5.3%
5	4677098	4.6%
6	4220907	4.2%
7	1585447	1.6%
3	46	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	25388890	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126944450	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	38084103	30.0%
1	34950787	27.5%
-	25388890	20.0%
2	12694445	10.0%
4	5342727	4.2%
5	4677098	3.7%
6	4220907	3.3%
7	1585447	1.2%
3	46	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126944450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	38084103	30.0%
1	34950787	27.5%
-	25388890	20.0%
2	12694445	10.0%
4	5342727	4.2%
5	4677098	3.7%
6	4220907	3.3%
7	1585447	1.2%
3	46	< 0.1%

RateExpirationDate
Categorical

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	811.1 MiB

2015-12-31	2877574
2016-12-31	2666681
2014-12-31	2341400
2015-06-30	612064
2015-03-31	600696
Other values (21)	3596030

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	126944450
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2014-12-31
2nd row	2014-12-31
3rd row	2014-12-31
4th row	2014-12-31
5th row	2014-12-31

Common Values

Value	Count	Frequency (%)
2015-12-31	2877574	22.7%
2016-12-31	2666681	21.0%
2014-12-31	2341400	18.4%
2015-06-30	612064	4.8%
2015-03-31	600696	4.7%
2015-09-30	600196	4.7%
2016-06-30	525495	4.1%
2016-03-31	512804	4.0%
2016-09-30	512799	4.0%
2014-06-30	441954	3.5%
Other values (16)	1002782	7.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2015-12-31	2877574	22.7%
2016-12-31	2666681	21.0%
2014-12-31	2341400	18.4%
2015-06-30	612064	4.8%
2015-03-31	600696	4.7%
2015-09-30	600196	4.7%
2016-06-30	525495	4.1%
2016-03-31	512804	4.0%
2016-09-30	512799	4.0%
2014-06-30	441954	3.5%
Other values (16)	1002782	7.9%

Most occurring characters

Value	Count	Frequency (%)
1	30266307	23.8%
-	25388890	20.0%
0	20724499	16.3%
2	20600234	16.2%
3	14128819	11.1%
6	5866016	4.6%
5	4752308	3.7%
4	3657888	2.9%
9	1547805	1.2%
8	8556	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	101555560	80.0%
Dash Punctuation	25388890	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	30266307	29.8%
0	20724499	20.4%
2	20600234	20.3%
3	14128819	13.9%
6	5866016	5.8%
5	4752308	4.7%
4	3657888	3.6%
9	1547805	1.5%
8	8556	< 0.1%
7	3128	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	25388890	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126944450	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	30266307	23.8%
-	25388890	20.0%
0	20724499	16.3%
2	20600234	16.2%
3	14128819	11.1%
6	5866016	4.6%
5	4752308	3.7%
4	3657888	2.9%
9	1547805	1.2%
8	8556	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126944450	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	30266307	23.8%
-	25388890	20.0%
0	20724499	16.3%
2	20600234	16.2%
3	14128819	11.1%
6	5866016	4.6%
5	4752308	3.7%
4	3657888	2.9%
9	1547805	1.2%
8	8556	< 0.1%

PlanId
Categorical

Distinct	16808
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	859.6 MiB

16842FL0010001	36984
16842FL0010002	36984
97325SC0080001	25392
26065SC0360001	25392
84966SC0120001	25392
Other values (16803)	12544301

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	177722230
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26 ?
Unique (%)	< 0.1%

Sample

1st row	21989AK0010001
2nd row	21989AK0020001
3rd row	21989AK0020001
4th row	21989AK0010001
5th row	21989AK0010001

Common Values

Value	Count	Frequency (%)
16842FL0010001	36984	0.3%
16842FL0010002	36984	0.3%
97325SC0080001	25392	0.2%
26065SC0360001	25392	0.2%
84966SC0120001	25392	0.2%
97325SC0080004	25392	0.2%
97325SC0080003	25392	0.2%
97325SC0080002	25392	0.2%
49532SC0370006	25392	0.2%
26065SC0360002	25392	0.2%
Other values (16798)	12417341	97.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
16842fl0010001	36984	0.3%
16842fl0010002	36984	0.3%
97325sc0080001	25392	0.2%
26065sc0360001	25392	0.2%
84966sc0120001	25392	0.2%
97325sc0080004	25392	0.2%
97325sc0080003	25392	0.2%
97325sc0080002	25392	0.2%
49532sc0370006	25392	0.2%
26065sc0360002	25392	0.2%
Other values (16795)	12417341	97.8%

Most occurring characters

Value	Count	Frequency (%)
0	57664747	32.4%
1	16869837	9.5%
2	13243952	7.5%
3	11973530	6.7%
5	9792709	5.5%
6	9475625	5.3%
4	9076191	5.1%
8	8206352	4.6%
7	8122312	4.6%
9	7908085	4.4%
Other values (26)	25388890	14.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	152333340	85.7%
Uppercase Letter	25388338	14.3%
Lowercase Letter	552	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249462	4.9%
Other values (14)	6079763	23.9%

Decimal Number

Value	Count	Frequency (%)
0	57664747	37.9%
1	16869837	11.1%
2	13243952	8.7%
3	11973530	7.9%
5	9792709	6.4%
6	9475625	6.2%
4	9076191	6.0%
8	8206352	5.4%
7	8122312	5.3%
9	7908085	5.2%

Lowercase Letter

Value	Count	Frequency (%)
t	276	50.0%
x	276	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	152333340	85.7%
Latin	25388890	14.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	3388258	13.3%
L	2504255	9.9%
A	2331150	9.2%
C	1929454	7.6%
S	1795756	7.1%
F	1702472	6.7%
N	1645580	6.5%
M	1473836	5.8%
O	1288352	5.1%
T	1249462	4.9%
Other values (16)	6080315	23.9%

Common

Value	Count	Frequency (%)
0	57664747	37.9%
1	16869837	11.1%
2	13243952	8.7%
3	11973530	7.9%
5	9792709	6.4%
6	9475625	6.2%
4	9076191	6.0%
8	8206352	5.4%
7	8122312	5.3%
9	7908085	5.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	177722230	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	57664747	32.4%
1	16869837	9.5%
2	13243952	7.5%
3	11973530	6.7%
5	9792709	5.5%
6	9475625	5.3%
4	9076191	5.1%
8	8206352	4.6%
7	8122312	4.6%
9	7908085	4.4%
Other values (26)	25388890	14.3%

RatingAreaId
Categorical

Distinct	67
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	852.8 MiB

Rating Area 1	978906
Rating Area 2	934953
Rating Area 3	920486
Rating Area 4	907736
Rating Area 5	823124
Other values (62)	8129240

Length

Max length	14
Median length	13
Mean length	13.44352
Min length	13

Characters and Unicode

Total characters	170658023
Distinct characters	20
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rating Area 1
2nd row	Rating Area 1
3rd row	Rating Area 2
4th row	Rating Area 1
5th row	Rating Area 1

Common Values

Value	Count	Frequency (%)
Rating Area 1	978906	7.7%
Rating Area 2	934953	7.4%
Rating Area 3	920486	7.3%
Rating Area 4	907736	7.2%
Rating Area 5	823124	6.5%
Rating Area 6	777974	6.1%
Rating Area 7	689508	5.4%
Rating Area 8	560491	4.4%
Rating Area 10	483493	3.8%
Rating Area 11	471504	3.7%
Other values (57)	5146270	40.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
rating	12694445	33.3%
area	12694445	33.3%
1	978906	2.6%
2	934953	2.5%
3	920486	2.4%
4	907736	2.4%
5	823124	2.2%
6	777974	2.0%
7	689508	1.8%
8	560491	1.5%
Other values (59)	6101267	16.0%

Most occurring characters

Value	Count	Frequency (%)
a	25388890	14.9%
	25388890	14.9%
R	12694445	7.4%
t	12694445	7.4%
i	12694445	7.4%
n	12694445	7.4%
g	12694445	7.4%
A	12694445	7.4%
r	12694445	7.4%
e	12694445	7.4%
Other values (10)	18324683	10.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	101555560	59.5%
Space Separator	25388890	14.9%
Uppercase Letter	25388890	14.9%
Decimal Number	18324683	10.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	5009239	27.3%
2	2365310	12.9%
3	2119916	11.6%
4	2072355	11.3%
5	1747129	9.5%
6	1616618	8.8%
7	1106220	6.0%
8	803121	4.4%
0	777004	4.2%
9	707771	3.9%

Lowercase Letter

Value	Count	Frequency (%)
a	25388890	25.0%
t	12694445	12.5%
i	12694445	12.5%
n	12694445	12.5%
g	12694445	12.5%
r	12694445	12.5%
e	12694445	12.5%

Uppercase Letter

Value	Count	Frequency (%)
R	12694445	50.0%
A	12694445	50.0%

Space Separator

Value	Count	Frequency (%)
	25388890	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	126944450	74.4%
Common	43713573	25.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
	25388890	58.1%
1	5009239	11.5%
2	2365310	5.4%
3	2119916	4.8%
4	2072355	4.7%
5	1747129	4.0%
6	1616618	3.7%
7	1106220	2.5%
8	803121	1.8%
0	777004	1.8%

Latin

Value	Count	Frequency (%)
a	25388890	20.0%
R	12694445	10.0%
t	12694445	10.0%
i	12694445	10.0%
n	12694445	10.0%
g	12694445	10.0%
A	12694445	10.0%
r	12694445	10.0%
e	12694445	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	170658023	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	25388890	14.9%
	25388890	14.9%
R	12694445	7.4%
t	12694445	7.4%
i	12694445	7.4%
n	12694445	7.4%
g	12694445	7.4%
A	12694445	7.4%
r	12694445	7.4%
e	12694445	7.4%
Other values (10)	18324683	10.7%

Tobacco
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	922.1 MiB

No Preference	7804323
Tobacco User/Non-Tobacco User	4890122

Length

Max length	29
Median length	13
Mean length	19.16348
Min length	13

Characters and Unicode

Total characters	243269737
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	No Preference
2nd row	No Preference
3rd row	No Preference
4th row	No Preference
5th row	No Preference

Common Values

Value	Count	Frequency (%)
No Preference	7804323	61.5%
Tobacco User/Non-Tobacco User	4890122	38.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
no	7804323	25.8%
preference	7804323	25.8%
tobacco	4890122	16.2%
user/non-tobacco	4890122	16.2%
user	4890122	16.2%

Most occurring characters

Value	Count	Frequency (%)
e	40997536	16.9%
o	32254933	13.3%
c	27364811	11.2%
r	25388890	10.4%
	17584567	7.2%
N	12694445	5.2%
n	12694445	5.2%
T	9780244	4.0%
b	9780244	4.0%
a	9780244	4.0%
Other values (6)	44949378	18.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	175845670	72.3%
Uppercase Letter	40059256	16.5%
Space Separator	17584567	7.2%
Other Punctuation	4890122	2.0%
Dash Punctuation	4890122	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	40997536	23.3%
o	32254933	18.3%
c	27364811	15.6%
r	25388890	14.4%
n	12694445	7.2%
b	9780244	5.6%
a	9780244	5.6%
s	9780244	5.6%
f	7804323	4.4%

Uppercase Letter

Value	Count	Frequency (%)
N	12694445	31.7%
T	9780244	24.4%
U	9780244	24.4%
P	7804323	19.5%

Space Separator

Value	Count	Frequency (%)
	17584567	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	4890122	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	4890122	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	215904926	88.8%
Common	27364811	11.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	40997536	19.0%
o	32254933	14.9%
c	27364811	12.7%
r	25388890	11.8%
N	12694445	5.9%
n	12694445	5.9%
T	9780244	4.5%
b	9780244	4.5%
a	9780244	4.5%
U	9780244	4.5%
Other values (3)	25388890	11.8%

Common

Value	Count	Frequency (%)
	17584567	64.3%
/	4890122	17.9%
-	4890122	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	243269737	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	40997536	16.9%
o	32254933	13.3%
c	27364811	11.2%
r	25388890	10.4%
	17584567	7.2%
N	12694445	5.2%
n	12694445	5.2%
T	9780244	4.0%
b	9780244	4.0%
a	9780244	4.0%
Other values (6)	44949378	18.5%

Age
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	715.3 MiB

IndividualRate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	149181
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4098.0265

Minimum	0
Maximum	999999
Zeros	682484
Zeros (%)	5.4%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	29.33
median	291.6
Q3	478.98
95-th percentile	948.39
Maximum	999999
Range	999999
Interquartile range (IQR)	449.65

Descriptive statistics

Standard deviation	61222.713
Coefficient of variation (CV)	14.93956
Kurtosis	260.59546
Mean	4098.0265
Median Absolute Deviation (MAD)	257.42
Skewness	16.204209
Sum	5.2022171 × 10¹⁰
Variance	3.7482205 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	682484	5.4%
99.99	87941	0.7%
999999	47790	0.4%
99	36455	0.3%
1.5	24660	0.2%
9999	23580	0.2%
18.49	15032	0.1%
25.68	13499	0.1%
21.99	13179	0.1%
36.3	11420	0.1%
Other values (149171)	11738405	92.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	682484	5.4%
0.01	24	< 0.1%
1.5	24660	0.2%
3.93	322	< 0.1%
5.55	1170	< 0.1%
6	6	< 0.1%
6.12	270	< 0.1%
6.6	2996	< 0.1%
6.68	1170	< 0.1%
7	12	< 0.1%

Value	Count	Frequency (%)
999999	47790	0.4%
9999.99	1080	< 0.1%
9999	23580	0.2%
5503.85	2	< 0.1%
5415.8	1	< 0.1%
5354.51	2	< 0.1%
5319.89	2	< 0.1%
5270.86	1	< 0.1%
5268.84	1	< 0.1%
5259.14	2	< 0.1%

IndividualTobaccoRate
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	153930
Distinct (%)	3.1%
Missing	7762096
Missing (%)	61.1%
Infinite	0
Infinite (%)	0.0%
Mean	543.69108

Minimum	41.73
Maximum	6604.61
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	41.73
5-th percentile	220.5
Q1	339.12
median	463.29
Q3	684.39
95-th percentile	1104.01
Maximum	6604.61
Range	6562.88
Interquartile range (IQR)	345.27

Descriptive statistics

Standard deviation	294.59158
Coefficient of variation (CV)	0.54183634
Kurtosis	17.612482
Mean	543.69108
Median Absolute Deviation (MAD)	151.89
Skewness	2.286002
Sum	2.6816742 × 10⁹
Variance	86784.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
306	381	< 0.1%
312	368	< 0.1%
369	353	< 0.1%
282	352	< 0.1%
252	351	< 0.1%
300	348	< 0.1%
295	342	< 0.1%
330	335	< 0.1%
347	333	< 0.1%
318	327	< 0.1%
Other values (153920)	4928859	38.8%
(Missing)	7762096	61.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.73	1	< 0.1%
42.64	1	< 0.1%
44.45	1	< 0.1%
55.66	1	< 0.1%
58.88	1	< 0.1%
59.4	1	< 0.1%
60.54	1	< 0.1%
60.59	1	< 0.1%
60.78	1	< 0.1%
60.8	1	< 0.1%

Value	Count	Frequency (%)
6604.61	2	< 0.1%
6498.95	1	< 0.1%
6425.42	2	< 0.1%
6383.87	2	< 0.1%
6325.03	1	< 0.1%
6322.61	1	< 0.1%
6310.97	2	< 0.1%
6306.2	2	< 0.1%
6305.81	4	< 0.1%
6291.89	2	< 0.1%

Couple
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	5533
Distinct (%)	13.5%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	48.115714

Minimum	0
Maximum	182.4
Zeros	6302
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	26.71
median	49.77
Q3	69.9
95-th percentile	97.06
Maximum	182.4
Range	182.4
Interquartile range (IQR)	43.19

Descriptive statistics

Standard deviation	30.422891
Coefficient of variation (CV)	0.63228597
Kurtosis	-0.7229547
Mean	48.115714
Median Absolute Deviation (MAD)	22.09
Skewness	0.044568678
Sum	1969905.5
Variance	925.5523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6302	< 0.1%
23.84	148	< 0.1%
24.05	148	< 0.1%
30.72	136	< 0.1%
30.19	136	< 0.1%
29.93	134	< 0.1%
16.53	134	< 0.1%
23.44	134	< 0.1%
23.64	134	< 0.1%
30.45	134	< 0.1%
Other values (5523)	33401	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6302	< 0.1%
0.01	24	< 0.1%
10	6	< 0.1%
11.11	26	< 0.1%
12	12	< 0.1%
14	6	< 0.1%
15	6	< 0.1%
15.61	67	< 0.1%
16.53	134	< 0.1%
17	6	< 0.1%

Value	Count	Frequency (%)
182.4	1	< 0.1%
181.86	1	< 0.1%
153.62	1	< 0.1%
151.67	2	< 0.1%
151.23	2	< 0.1%
145.92	1	< 0.1%
145.49	1	< 0.1%
138.15	1	< 0.1%
137.72	1	< 0.1%
136.95	1	< 0.1%

PrimarySubscriberAndOneDependent
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	5974
Distinct (%)	14.6%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	49.835901

Minimum	0
Maximum	169.65
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0.74
Q1	27.39
median	51.24
Q3	72.23
95-th percentile	95.03
Maximum	169.65
Range	169.65
Interquartile range (IQR)	44.84

Descriptive statistics

Standard deviation	29.691985
Coefficient of variation (CV)	0.59579509
Kurtosis	-0.56205208
Mean	49.835901
Median Absolute Deviation (MAD)	22.22
Skewness	0.11121116
Sum	2040331.6
Variance	881.61398
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
7.35	1037	< 0.1%
4.41	929	< 0.1%
7.72	834	< 0.1%
4.63	798	< 0.1%
3.68	274	< 0.1%
0.74	262	< 0.1%
64.7	150	< 0.1%
23.84	148	< 0.1%
24.05	148	< 0.1%
Other values (5964)	34513	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
0.74	262	< 0.1%
3.68	274	< 0.1%
4.41	929	< 0.1%
4.59	75	< 0.1%
4.63	798	< 0.1%
4.82	75	< 0.1%
5.3	12	< 0.1%
6.5	12	< 0.1%
7.35	1037	< 0.1%

Value	Count	Frequency (%)
169.65	1	< 0.1%
169.15	1	< 0.1%
159.14	3	< 0.1%
151.41	1	< 0.1%
150.97	1	< 0.1%
148.17	1	< 0.1%
146.58	14	< 0.1%
144.87	14	< 0.1%
143.68	3	< 0.1%
143.45	1	< 0.1%

PrimarySubscriberAndTwoDependents
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7047
Distinct (%)	17.2%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	70.660012

Minimum	0
Maximum	251.74
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1.47
Q1	27.91
median	74.68
Q3	107.67
95-th percentile	138.09
Maximum	251.74
Range	251.74
Interquartile range (IQR)	79.76

Descriptive statistics

Standard deviation	44.62013
Coefficient of variation (CV)	0.63147641
Kurtosis	-1.1272255
Mean	70.660012
Median Absolute Deviation (MAD)	41.77
Skewness	0.059702428
Sum	2892891.6
Variance	1990.956
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
8.82	929	< 0.1%
14.71	811	< 0.1%
9.26	798	< 0.1%
15.45	609	< 0.1%
7.35	274	< 0.1%
1.47	262	< 0.1%
14.7	225	< 0.1%
15.44	225	< 0.1%
128.25	154	< 0.1%
Other values (7037)	34806	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
1.47	262	< 0.1%
5.3	12	< 0.1%
6.5	12	< 0.1%
7.35	274	< 0.1%
8.82	929	< 0.1%
9.18	75	< 0.1%
9.26	798	< 0.1%
9.64	75	< 0.1%
14.7	225	< 0.1%

Value	Count	Frequency (%)
251.74	3	< 0.1%
248.11	1	< 0.1%
247.38	1	< 0.1%
226.99	1	< 0.1%
226.32	1	< 0.1%
220.83	3	< 0.1%
212.7	1	< 0.1%
208.96	1	< 0.1%
202.73	1	< 0.1%
202.04	1	< 0.1%

PrimarySubscriberAndThreeOrMoreDependents
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7632
Distinct (%)	18.6%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	89.405494

Minimum	0
Maximum	357.94
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	2.94
Q1	29.41
median	98.8
Q3	137.08
95-th percentile	175.77
Maximum	357.94
Range	357.94
Interquartile range (IQR)	107.67

Descriptive statistics

Standard deviation	57.699279
Coefficient of variation (CV)	0.64536614
Kurtosis	-1.1698297
Mean	89.405494
Median Absolute Deviation (MAD)	54.8
Skewness	0.065631563
Sum	3660350.3
Variance	3329.2068
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
29.41	764	< 0.1%
17.65	656	< 0.1%
30.9	577	< 0.1%
18.52	525	< 0.1%
14.71	274	< 0.1%
22.05	273	< 0.1%
13.23	273	< 0.1%
23.16	273	< 0.1%
13.89	273	< 0.1%
Other values (7622)	35205	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
2.94	262	< 0.1%
5.3	12	< 0.1%
6.5	12	< 0.1%
13.23	273	< 0.1%
13.76	24	< 0.1%
13.77	51	< 0.1%
13.89	273	< 0.1%
14.45	24	< 0.1%
14.46	51	< 0.1%

Value	Count	Frequency (%)
357.94	1	< 0.1%
356.89	1	< 0.1%
344.34	3	< 0.1%
332.8	1	< 0.1%
331.82	1	< 0.1%
301.47	1	< 0.1%
297.99	3	< 0.1%
286.35	1	< 0.1%
285.51	1	< 0.1%
282.85	1	< 0.1%

CoupleAndOneDependent
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7268
Distinct (%)	17.8%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	72.782793

Minimum	0
Maximum	260.85
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0.74
Q1	28.26
median	77.25
Q3	110.43
95-th percentile	146.28
Maximum	260.85
Range	260.85
Interquartile range (IQR)	82.17

Descriptive statistics

Standard deviation	48.232537
Coefficient of variation (CV)	0.66269148
Kurtosis	-0.88702674
Mean	72.782793
Median Absolute Deviation (MAD)	43.86
Skewness	0.13836831
Sum	2979800.3
Variance	2326.3776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
7.35	1037	< 0.1%
4.41	929	< 0.1%
7.72	834	< 0.1%
4.63	798	< 0.1%
3.68	274	< 0.1%
0.74	262	< 0.1%
24.05	148	< 0.1%
23.84	148	< 0.1%
91.5	136	< 0.1%
Other values (7258)	34527	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
0.74	262	< 0.1%
3.68	274	< 0.1%
4.41	929	< 0.1%
4.59	75	< 0.1%
4.63	798	< 0.1%
4.82	75	< 0.1%
7.1	12	< 0.1%
7.35	1037	< 0.1%
7.64	75	< 0.1%

Value	Count	Frequency (%)
260.85	1	< 0.1%
260.08	1	< 0.1%
227.25	1	< 0.1%
226.58	1	< 0.1%
225.67	3	< 0.1%
222.79	14	< 0.1%
220.19	14	< 0.1%
219.69	1	< 0.1%
217.63	14	< 0.1%
216.3	1	< 0.1%

CoupleAndTwoDependents
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7733
Distinct (%)	18.9%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	89.012859

Minimum	0
Maximum	339.31
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	1.47
Q1	28.26
median	97.91
Q3	136.33
95-th percentile	179.74
Maximum	339.31
Range	339.31
Interquartile range (IQR)	108.07

Descriptive statistics

Standard deviation	59.139094
Coefficient of variation (CV)	0.66438821
Kurtosis	-1.1492624
Mean	89.012859
Median Absolute Deviation (MAD)	55.23
Skewness	0.058426912
Sum	3644275.4
Variance	3497.4324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
8.82	929	< 0.1%
14.71	812	< 0.1%
9.26	798	< 0.1%
15.45	609	< 0.1%
7.35	274	< 0.1%
1.47	262	< 0.1%
14.7	225	< 0.1%
15.44	225	< 0.1%
23.84	148	< 0.1%
Other values (7723)	34811	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
1.47	262	< 0.1%
7.1	12	< 0.1%
7.35	274	< 0.1%
8.7	12	< 0.1%
8.82	929	< 0.1%
9.18	75	< 0.1%
9.26	798	< 0.1%
9.64	75	< 0.1%
14.7	225	< 0.1%

Value	Count	Frequency (%)
339.31	1	< 0.1%
338.31	1	< 0.1%
318.27	3	< 0.1%
302.83	1	< 0.1%
301.94	1	< 0.1%
287.37	3	< 0.1%
285.77	1	< 0.1%
273.44	1	< 0.1%
272.64	1	< 0.1%
271.45	1	< 0.1%

CoupleAndThreeOrMoreDependents
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	8197
Distinct (%)	20.0%
Missing	12653504
Missing (%)	99.7%
Infinite	0
Infinite (%)	0.0%
Mean	107.80777

Minimum	0
Maximum	449.14
Zeros	1848
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	0
5-th percentile	2.94
Q1	29.49
median	116.71
Q3	167.96
95-th percentile	220.02
Maximum	449.14
Range	449.14
Interquartile range (IQR)	138.47

Descriptive statistics

Standard deviation	73.241174
Coefficient of variation (CV)	0.6793682
Kurtosis	-1.1498462
Mean	107.80777
Median Absolute Deviation (MAD)	72.59
Skewness	0.11742448
Sum	4413758.1
Variance	5364.2695
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1848	< 0.1%
29.41	764	< 0.1%
17.65	656	< 0.1%
30.9	577	< 0.1%
18.52	525	< 0.1%
14.71	274	< 0.1%
22.05	273	< 0.1%
13.23	273	< 0.1%
23.16	273	< 0.1%
13.89	273	< 0.1%
Other values (8187)	35205	0.3%
(Missing)	12653504	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1848	< 0.1%
2.94	262	< 0.1%
7.1	12	< 0.1%
8.7	12	< 0.1%
13.23	273	< 0.1%
13.76	24	< 0.1%
13.77	51	< 0.1%
13.89	273	< 0.1%
14.45	24	< 0.1%
14.46	51	< 0.1%

Value	Count	Frequency (%)
449.14	1	< 0.1%
447.82	1	< 0.1%
410.88	3	< 0.1%
408.64	1	< 0.1%
407.43	1	< 0.1%
378.27	1	< 0.1%
364.52	3	< 0.1%
359.31	1	< 0.1%
358.68	1	< 0.1%
358.26	1	< 0.1%

RowNumber
Real number (ℝ)

Distinct	60444
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6348.5724

Minimum	14
Maximum	63493
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	96.9 MiB

Quantile statistics

Minimum	14
5-th percentile	131
Q1	873
median	2728
Q3	7577
95-th percentile	26079
Maximum	63493
Range	63479
Interquartile range (IQR)	6704

Descriptive statistics

Standard deviation	9011.435
Coefficient of variation (CV)	1.4194427
Kurtosis	6.6476121
Mean	6348.5724
Median Absolute Deviation (MAD)	2279
Skewness	2.4522055
Sum	8.0591603 × 10¹⁰
Variance	81205960
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	6266	< 0.1%
15	6263	< 0.1%
16	6242	< 0.1%
17	6221	< 0.1%
18	6185	< 0.1%
19	6173	< 0.1%
20	6139	< 0.1%
21	6113	< 0.1%
22	6041	< 0.1%
23	6033	< 0.1%
Other values (60434)	12632769	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	6266	< 0.1%
15	6263	< 0.1%
16	6242	< 0.1%
17	6221	< 0.1%
18	6185	< 0.1%
19	6173	< 0.1%
20	6139	< 0.1%
21	6113	< 0.1%
22	6041	< 0.1%
23	6033	< 0.1%

Value	Count	Frequency (%)
63493	4	< 0.1%
63492	4	< 0.1%
63491	4	< 0.1%
63490	4	< 0.1%
63489	4	< 0.1%
63488	4	< 0.1%
63487	4	< 0.1%
63486	4	< 0.1%
63485	4	< 0.1%
63484	4	< 0.1%

Auto

Heatmap
Table

	IssuerId	VersionNum	IssuerId2	IndividualRate	IndividualTobaccoRate	Couple	PrimarySubscriberAndOneDependent	PrimarySubscriberAndTwoDependents	PrimarySubscriberAndThreeOrMoreDependents	CoupleAndOneDependent	CoupleAndTwoDependents	CoupleAndThreeOrMoreDependents	RowNumber	BusinessYear	StateCode	SourceName	RateEffectiveDate	RateExpirationDate	RatingAreaId	Tobacco
IssuerId	1.000	-0.110	1.000	-0.075	0.024	0.001	-0.005	-0.002	0.001	-0.004	-0.011	-0.006	-0.059	0.092	0.354	0.212	0.063	0.091	0.133	0.308
VersionNum	-0.110	1.000	-0.110	0.324	0.031	-0.123	-0.116	-0.135	-0.110	-0.105	-0.106	-0.083	0.171	0.245	0.272	0.146	0.144	0.149	0.102	0.327
IssuerId2	1.000	-0.110	1.000	-0.075	0.024	0.001	-0.005	-0.002	0.001	-0.004	-0.011	-0.006	-0.059	0.092	0.354	0.212	0.063	0.091	0.133	0.308
IndividualRate	-0.075	0.324	-0.075	1.000	0.977	0.769	0.706	0.696	0.655	0.701	0.706	0.646	0.087	0.094	0.057	0.008	0.173	0.129	0.016	0.049
IndividualTobaccoRate	0.024	0.031	0.024	0.977	1.000	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.077	0.046	0.090	0.060	0.046	0.043	0.027	0.010
Couple	0.001	-0.123	0.001	0.769	NaN	1.000	0.972	0.967	0.939	0.976	0.980	0.938	-0.241	0.267	0.175	0.190	0.244	0.243	0.055	1.000
PrimarySubscriberAndOneDependent	-0.005	-0.116	-0.005	0.706	NaN	0.972	1.000	0.978	0.936	0.994	0.979	0.927	-0.218	0.293	0.198	0.218	0.231	0.231	0.055	1.000
PrimarySubscriberAndTwoDependents	-0.002	-0.135	-0.002	0.696	NaN	0.967	0.978	1.000	0.960	0.982	0.974	0.930	-0.195	0.306	0.178	0.164	0.205	0.205	0.049	1.000
PrimarySubscriberAndThreeOrMoreDependents	0.001	-0.110	0.001	0.655	NaN	0.939	0.936	0.960	1.000	0.928	0.974	0.985	-0.187	0.248	0.185	0.149	0.162	0.164	0.036	1.000
CoupleAndOneDependent	-0.004	-0.105	-0.004	0.701	NaN	0.976	0.994	0.982	0.928	1.000	0.975	0.915	-0.209	0.297	0.194	0.224	0.208	0.206	0.057	1.000
CoupleAndTwoDependents	-0.011	-0.106	-0.011	0.706	NaN	0.980	0.979	0.974	0.974	0.975	1.000	0.977	-0.203	0.252	0.188	0.188	0.183	0.183	0.054	1.000
CoupleAndThreeOrMoreDependents	-0.006	-0.083	-0.006	0.646	NaN	0.938	0.927	0.930	0.985	0.915	0.977	1.000	-0.187	0.237	0.180	0.137	0.173	0.173	0.041	1.000
RowNumber	-0.059	0.171	-0.059	0.087	0.077	-0.241	-0.218	-0.195	-0.187	-0.209	-0.203	-0.187	1.000	0.068	0.175	0.117	0.055	0.057	0.128	0.216
BusinessYear	0.092	0.245	0.092	0.094	0.046	0.267	0.293	0.306	0.248	0.297	0.252	0.237	0.068	1.000	0.187	0.020	1.000	0.990	0.062	0.064
StateCode	0.354	0.272	0.354	0.057	0.090	0.175	0.198	0.178	0.185	0.194	0.188	0.180	0.175	0.187	1.000	0.719	0.114	0.119	0.190	0.387
SourceName	0.212	0.146	0.212	0.008	0.060	0.190	0.218	0.164	0.149	0.224	0.188	0.137	0.117	0.020	0.719	1.000	0.055	0.103	0.245	0.090
RateEffectiveDate	0.063	0.144	0.063	0.173	0.046	0.244	0.231	0.205	0.162	0.208	0.183	0.173	0.055	1.000	0.114	0.055	1.000	0.772	0.045	0.113
RateExpirationDate	0.091	0.149	0.091	0.129	0.043	0.243	0.231	0.205	0.164	0.206	0.183	0.173	0.057	0.990	0.119	0.103	0.772	1.000	0.038	0.161
RatingAreaId	0.133	0.102	0.133	0.016	0.027	0.055	0.055	0.049	0.036	0.057	0.054	0.041	0.128	0.062	0.190	0.245	0.045	0.038	1.000	0.147
Tobacco	0.308	0.327	0.308	0.049	0.010	1.000	1.000	1.000	1.000	1.000	1.000	1.000	0.216	0.064	0.387	0.090	0.113	0.161	0.147	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	BusinessYear	StateCode	IssuerId	SourceName	VersionNum	ImportDate	IssuerId2	FederalTIN	RateEffectiveDate	RateExpirationDate	PlanId	RatingAreaId	Tobacco	Age	IndividualRate	IndividualTobaccoRate	Couple	PrimarySubscriberAndOneDependent	PrimarySubscriberAndTwoDependents	PrimarySubscriberAndThreeOrMoreDependents	CoupleAndOneDependent	CoupleAndTwoDependents	CoupleAndThreeOrMoreDependents	RowNumber
0	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0010001	Rating Area 1	No Preference	0-20	29.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	14
1	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0020001	Rating Area 1	No Preference	Family Option	36.95	NaN	73.9	107.61	107.61	107.61	144.56	144.56	144.56	14
2	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0020001	Rating Area 2	No Preference	Family Option	36.95	NaN	73.9	107.61	107.61	107.61	144.56	144.56	144.56	15
3	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0010001	Rating Area 1	No Preference	21	32.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	15
4	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0010001	Rating Area 1	No Preference	22	32.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	16
5	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0020001	Rating Area 3	No Preference	Family Option	36.95	NaN	73.9	107.61	107.61	107.61	144.56	144.56	144.56	16
6	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0020002	Rating Area 1	No Preference	Family Option	32.45	NaN	64.9	94.50	94.50	94.50	126.95	126.95	126.95	17
7	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0010001	Rating Area 1	No Preference	23	32.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	17
8	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0010001	Rating Area 1	No Preference	24	32.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	18
9	2014	AK	21989	HIOS	6	2014-03-19 07:06:49	21989	93-0438772	2014-01-01	2014-12-31	21989AK0020002	Rating Area 2	No Preference	Family Option	32.45	NaN	64.9	94.50	94.50	94.50	126.95	126.95	126.95	18

	BusinessYear	StateCode	IssuerId	SourceName	VersionNum	ImportDate	IssuerId2	FederalTIN	RateEffectiveDate	RateExpirationDate	PlanId	RatingAreaId	Tobacco	Age	IndividualRate	IndividualTobaccoRate	Couple	PrimarySubscriberAndOneDependent	PrimarySubscriberAndTwoDependents	PrimarySubscriberAndThreeOrMoreDependents	CoupleAndOneDependent	CoupleAndTwoDependents	CoupleAndThreeOrMoreDependents	RowNumber
12694435	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	56	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2028
12694436	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	57	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2029
12694437	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	58	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2030
12694438	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	59	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2031
12694439	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	60	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2032
12694440	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	61	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2033
12694441	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	62	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2034
12694442	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	63	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2035
12694443	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	64	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2036
12694444	2016	WV	96480	SERFF	2	2015-08-20 12:28:36	96480	13-5123390	2016-01-01	2016-12-31	96480WV0090003	Rating Area 11	No Preference	65 and over	14.05	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2037

Most frequently occurring

	BusinessYear	StateCode	IssuerId	SourceName	VersionNum	ImportDate	IssuerId2	FederalTIN	RateEffectiveDate	RateExpirationDate	PlanId	RatingAreaId	Tobacco	IndividualRate	IndividualTobaccoRate	Couple	PrimarySubscriberAndOneDependent	PrimarySubscriberAndTwoDependents	PrimarySubscriberAndThreeOrMoreDependents	CoupleAndOneDependent	CoupleAndTwoDependents	CoupleAndThreeOrMoreDependents	RowNumber	# duplicates
0	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	152	2
1	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	153	2
2	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	154	2
3	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	155	2
4	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	156	2
5	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	157	2
6	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	158	2
7	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	159	2
8	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	160	2
9	2014	AL	82285	HIOS	7	2014-01-21 08:29:49	82285	94-2761537	2014-01-01	2014-12-31	82285AL0010001	Rating Area 1	No Preference	19.42	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	161	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block